fe727cf1a08055fcb5cc75cc4d7eade198b9fc9f,bobas.businessobjectscommon.db.mysql/src/main/java/org/colorcoding/ibas/bobas/db/mysql/SqlScripts.java,SqlScripts,getUpdateBOPrimaryKeyScript,#String#,99
Before Change
*/
@Override
public String getUpdateBOPrimaryKeyScript(String boCode) throws SqlScriptsException {
return String.format("UPDATE `%s_SYS_ONNM` SET `AutoKey` = `AutoKey` + 1 WHERE `ObjectCode` = '%s'",
this.getCompanyId(), boCode);
}
/**
After Change
*/
@Override
public String getUpdateBOPrimaryKeyScript(String boCode) throws SqlScriptsException {
StringBuilder stringBuilder = new StringBuilder();
stringBuilder.append("UPDATE");
stringBuilder.append(" ");
stringBuilder.appendFormat("`%s_SYS_ONNM`", this.getCompanyId());
stringBuilder.append(" ");
stringBuilder.append("SET");
stringBuilder.append(" ");
stringBuilder.append("`AutoKey`");
stringBuilder.append(" ");
stringBuilder.append("=");
stringBuilder.append(" ");
stringBuilder.append("`AutoKey`");
stringBuilder.append(" ");
stringBuilder.append("+");
stringBuilder.append(" ");
stringBuilder.append("1");
stringBuilder.append(" ");
stringBuilder.append("WHERE");
stringBuilder.append(" ");
stringBuilder.append("`ObjectCode`");
stringBuilder.append(" ");
stringBuilder.append("=");
stringBuilder.append(" ");
stringBuilder.append("'");
stringBuilder.append(boCode);
stringBuilder.append("'");
return stringBuilder.toString();
}
/**